Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 55440 |
| Missing cells | 61134 |
| Missing cells (%) | 10.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 11.1 MiB |
| Average record size in memory | 209.1 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 2 |
Country has a high cardinality: 231 distinct values | High cardinality |
Unnamed: 0 is highly correlated with Year | High correlation |
Year is highly correlated with Unnamed: 0 | High correlation |
Energy_consumption is highly correlated with Energy_production and 3 other fields | High correlation |
Energy_production is highly correlated with Energy_consumption and 2 other fields | High correlation |
GDP is highly correlated with Energy_consumption and 2 other fields | High correlation |
Population is highly correlated with Energy_consumption and 2 other fields | High correlation |
Energy_intensity_per_capita is highly correlated with Energy_intensity_by_GDP | High correlation |
Energy_intensity_by_GDP is highly correlated with Energy_intensity_per_capita | High correlation |
CO2_emission is highly correlated with Energy_consumption | High correlation |
Unnamed: 0 is highly correlated with Year | High correlation |
Year is highly correlated with Unnamed: 0 | High correlation |
Energy_consumption is highly correlated with Energy_production and 3 other fields | High correlation |
Energy_production is highly correlated with Energy_consumption and 3 other fields | High correlation |
GDP is highly correlated with Energy_consumption and 3 other fields | High correlation |
Population is highly correlated with Energy_consumption and 3 other fields | High correlation |
CO2_emission is highly correlated with Energy_consumption and 3 other fields | High correlation |
Unnamed: 0 is highly correlated with Year | High correlation |
Year is highly correlated with Unnamed: 0 | High correlation |
Energy_consumption is highly correlated with Energy_production and 2 other fields | High correlation |
Energy_production is highly correlated with Energy_consumption | High correlation |
GDP is highly correlated with Energy_consumption and 1 other fields | High correlation |
Population is highly correlated with GDP | High correlation |
Energy_intensity_per_capita is highly correlated with Energy_intensity_by_GDP | High correlation |
Energy_intensity_by_GDP is highly correlated with Energy_intensity_per_capita | High correlation |
CO2_emission is highly correlated with Energy_consumption | High correlation |
Unnamed: 0 is highly correlated with Year | High correlation |
Year is highly correlated with Unnamed: 0 | High correlation |
Energy_consumption is highly correlated with Energy_production and 3 other fields | High correlation |
Energy_production is highly correlated with Energy_consumption and 3 other fields | High correlation |
GDP is highly correlated with Energy_consumption and 3 other fields | High correlation |
Population is highly correlated with Energy_consumption and 3 other fields | High correlation |
CO2_emission is highly correlated with Energy_consumption and 3 other fields | High correlation |
Energy_consumption has 11153 (20.1%) missing values | Missing |
Energy_production has 11151 (20.1%) missing values | Missing |
GDP has 15414 (27.8%) missing values | Missing |
Population has 9426 (17.0%) missing values | Missing |
Energy_intensity_per_capita has 5082 (9.2%) missing values | Missing |
Energy_intensity_by_GDP has 5082 (9.2%) missing values | Missing |
CO2_emission has 3826 (6.9%) missing values | Missing |
Energy_consumption is highly skewed (γ1 = 23.92149736) | Skewed |
Energy_production is highly skewed (γ1 = 24.16400807) | Skewed |
CO2_emission is highly skewed (γ1 = 24.07524101) | Skewed |
Unnamed: 0 is uniformly distributed | Uniform |
Country is uniformly distributed | Uniform |
Energy_type is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
Energy_consumption has 10995 (19.8%) zeros | Zeros |
Energy_production has 20002 (36.1%) zeros | Zeros |
Energy_intensity_per_capita has 5784 (10.4%) zeros | Zeros |
Energy_intensity_by_GDP has 11442 (20.6%) zeros | Zeros |
CO2_emission has 26954 (48.6%) zeros | Zeros |
Reproduction
| Analysis started | 2022-06-19 08:44:22.842702 |
|---|---|
| Analysis finished | 2022-06-19 08:45:05.736079 |
| Duration | 42.89 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIFORMUNIQUE| Distinct | 55440 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27719.5 |
| Minimum | 0 |
|---|---|
| Maximum | 55439 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 433.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2771.95 |
| Q1 | 13859.75 |
| median | 27719.5 |
| Q3 | 41579.25 |
| 95-th percentile | 52667.05 |
| Maximum | 55439 |
| Range | 55439 |
| Interquartile range (IQR) | 27719.5 |
Descriptive statistics
| Standard deviation | 16004.2938 |
|---|---|
| Coefficient of variation (CV) | 0.5773658904 |
| Kurtosis | -1.2 |
| Mean | 27719.5 |
| Median Absolute Deviation (MAD) | 13860 |
| Skewness | 0 |
| Sum | 1536769080 |
| Variance | 256137420 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 36964 | 1 | < 0.1% |
| 36953 | 1 | < 0.1% |
| 36954 | 1 | < 0.1% |
| 36955 | 1 | < 0.1% |
| 36956 | 1 | < 0.1% |
| 36957 | 1 | < 0.1% |
| 36958 | 1 | < 0.1% |
| 36959 | 1 | < 0.1% |
| 36960 | 1 | < 0.1% |
| Other values (55430) | 55430 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 55439 | 1 | |
| 55438 | 1 | |
| 55437 | 1 | |
| 55436 | 1 | |
| 55435 | 1 | |
| 55434 | 1 | |
| 55433 | 1 | |
| 55432 | 1 | |
| 55431 | 1 | |
| 55430 | 1 |
| Distinct | 231 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.5 MiB |
| World | 240 |
|---|---|
| Netherlands Antilles | 240 |
| New Zealand | 240 |
| Nicaragua | 240 |
| Niger | 240 |
| Other values (226) |
Length
| Max length | 28 |
|---|---|
| Median length | 23 |
| Mean length | 9.402597403 |
| Min length | 4 |
Characters and Unicode
| Total characters | 521280 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | World |
|---|---|
| 2nd row | World |
| 3rd row | World |
| 4th row | World |
| 5th row | World |
Common Values
| Value | Count | Frequency (%) |
| World | 240 | 0.4% |
| Netherlands Antilles | 240 | 0.4% |
| New Zealand | 240 | 0.4% |
| Nicaragua | 240 | 0.4% |
| Niger | 240 | 0.4% |
| Nigeria | 240 | 0.4% |
| Niue | 240 | 0.4% |
| North Korea | 240 | 0.4% |
| North Macedonia | 240 | 0.4% |
| Northern Mariana Islands | 240 | 0.4% |
| Other values (221) | 53040 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| islands | 2400 | 3.2% |
| and | 1920 | 2.6% |
| saint | 1200 | 1.6% |
| former | 960 | 1.3% |
| new | 720 | 1.0% |
| u.s | 720 | 1.0% |
| germany | 720 | 1.0% |
| south | 720 | 1.0% |
| guinea | 720 | 1.0% |
| republic | 720 | 1.0% |
| Other values (255) | 64320 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 74880 | |
| i | 43440 | 8.3% |
| n | 41520 | 8.0% |
| e | 37200 | 7.1% |
| r | 32160 | 6.2% |
| o | 27600 | 5.3% |
| s | 20160 | 3.9% |
| 19680 | 3.8% | |
| t | 19200 | 3.7% |
| l | 18960 | 3.6% |
| Other values (48) | 186480 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 421200 | |
| Uppercase Letter | 75840 | 14.5% |
| Space Separator | 19680 | 3.8% |
| Other Punctuation | 3360 | 0.6% |
| Dash Punctuation | 960 | 0.2% |
| Final Punctuation | 240 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 74880 | |
| i | 43440 | |
| n | 41520 | |
| e | 37200 | |
| r | 32160 | 7.6% |
| o | 27600 | 6.6% |
| s | 20160 | 4.8% |
| t | 19200 | 4.6% |
| l | 18960 | 4.5% |
| u | 18720 | 4.4% |
| Other values (17) | 87360 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 9120 | 12.0% |
| C | 5520 | 7.3% |
| B | 5520 | 7.3% |
| M | 5280 | 7.0% |
| G | 5040 | 6.6% |
| I | 4800 | 6.3% |
| T | 4800 | 6.3% |
| A | 4320 | 5.7% |
| N | 4080 | 5.4% |
| P | 3360 | 4.4% |
| Other values (15) | 24000 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 2400 | |
| , | 720 | 21.4% |
| / | 240 | 7.1% |
Space Separator
| Value | Count | Frequency (%) |
| 19680 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 960 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 240 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 497040 | |
| Common | 24240 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 74880 | |
| i | 43440 | 8.7% |
| n | 41520 | 8.4% |
| e | 37200 | 7.5% |
| r | 32160 | 6.5% |
| o | 27600 | 5.6% |
| s | 20160 | 4.1% |
| t | 19200 | 3.9% |
| l | 18960 | 3.8% |
| u | 18720 | 3.8% |
| Other values (42) | 163200 |
Common
| Value | Count | Frequency (%) |
| 19680 | ||
| . | 2400 | 9.9% |
| - | 960 | 4.0% |
| , | 720 | 3.0% |
| / | 240 | 1.0% |
| ’ | 240 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 520800 | |
| None | 240 | < 0.1% |
| Punctuation | 240 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 74880 | |
| i | 43440 | 8.3% |
| n | 41520 | 8.0% |
| e | 37200 | 7.1% |
| r | 32160 | 6.2% |
| o | 27600 | 5.3% |
| s | 20160 | 3.9% |
| 19680 | 3.8% | |
| t | 19200 | 3.7% |
| l | 18960 | 3.6% |
| Other values (46) | 186000 |
None
| Value | Count | Frequency (%) |
| ô | 240 |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 240 |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 MiB |
| all_energy_types | |
|---|---|
| coal | |
| natural_gas | |
| petroleum_n_other_liquids | |
| nuclear |
Length
| Max length | 25 |
|---|---|
| Median length | 13.5 |
| Mean length | 13.5 |
| Min length | 4 |
Characters and Unicode
| Total characters | 748440 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | all_energy_types |
|---|---|
| 2nd row | coal |
| 3rd row | natural_gas |
| 4th row | petroleum_n_other_liquids |
| 5th row | nuclear |
Common Values
| Value | Count | Frequency (%) |
| all_energy_types | 9240 | |
| coal | 9240 | |
| natural_gas | 9240 | |
| petroleum_n_other_liquids | 9240 | |
| nuclear | 9240 | |
| renewables_n_other | 9240 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| all_energy_types | 9240 | |
| coal | 9240 | |
| natural_gas | 9240 | |
| petroleum_n_other_liquids | 9240 | |
| nuclear | 9240 | |
| renewables_n_other | 9240 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 101640 | |
| l | 73920 | |
| _ | 73920 | |
| a | 64680 | |
| r | 64680 | |
| n | 55440 | 7.4% |
| t | 46200 | 6.2% |
| u | 36960 | 4.9% |
| o | 36960 | 4.9% |
| s | 36960 | 4.9% |
| Other values (11) | 157080 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 674520 | |
| Connector Punctuation | 73920 | 9.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 101640 | |
| l | 73920 | |
| a | 64680 | |
| r | 64680 | |
| n | 55440 | 8.2% |
| t | 46200 | 6.8% |
| u | 36960 | 5.5% |
| o | 36960 | 5.5% |
| s | 36960 | 5.5% |
| p | 18480 | 2.7% |
| Other values (10) | 138600 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 73920 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 674520 | |
| Common | 73920 | 9.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 101640 | |
| l | 73920 | |
| a | 64680 | |
| r | 64680 | |
| n | 55440 | 8.2% |
| t | 46200 | 6.8% |
| u | 36960 | 5.5% |
| o | 36960 | 5.5% |
| s | 36960 | 5.5% |
| p | 18480 | 2.7% |
| Other values (10) | 138600 |
Common
| Value | Count | Frequency (%) |
| _ | 73920 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 748440 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 101640 | |
| l | 73920 | |
| _ | 73920 | |
| a | 64680 | |
| r | 64680 | |
| n | 55440 | 7.4% |
| t | 46200 | 6.2% |
| u | 36960 | 4.9% |
| o | 36960 | 4.9% |
| s | 36960 | 4.9% |
| Other values (11) | 157080 |
| Distinct | 40 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1999.5 |
| Minimum | 1980 |
|---|---|
| Maximum | 2019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 433.2 KiB |
Quantile statistics
| Minimum | 1980 |
|---|---|
| 5-th percentile | 1981.95 |
| Q1 | 1989.75 |
| median | 1999.5 |
| Q3 | 2009.25 |
| 95-th percentile | 2017.05 |
| Maximum | 2019 |
| Range | 39 |
| Interquartile range (IQR) | 19.5 |
Descriptive statistics
| Standard deviation | 11.54350049 |
|---|---|
| Coefficient of variation (CV) | 0.005773193543 |
| Kurtosis | -1.201501073 |
| Mean | 1999.5 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 0 |
| Sum | 110852280 |
| Variance | 133.2524035 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=40)
| Value | Count | Frequency (%) |
| 1980 | 1386 | 2.5% |
| 1981 | 1386 | 2.5% |
| 2002 | 1386 | 2.5% |
| 2003 | 1386 | 2.5% |
| 2004 | 1386 | 2.5% |
| 2005 | 1386 | 2.5% |
| 2006 | 1386 | 2.5% |
| 2007 | 1386 | 2.5% |
| 2008 | 1386 | 2.5% |
| 2009 | 1386 | 2.5% |
| Other values (30) | 41580 |
| Value | Count | Frequency (%) |
| 1980 | 1386 | |
| 1981 | 1386 | |
| 1982 | 1386 | |
| 1983 | 1386 | |
| 1984 | 1386 | |
| 1985 | 1386 | |
| 1986 | 1386 | |
| 1987 | 1386 | |
| 1988 | 1386 | |
| 1989 | 1386 |
| Value | Count | Frequency (%) |
| 2019 | 1386 | |
| 2018 | 1386 | |
| 2017 | 1386 | |
| 2016 | 1386 | |
| 2015 | 1386 | |
| 2014 | 1386 | |
| 2013 | 1386 | |
| 2012 | 1386 | |
| 2011 | 1386 | |
| 2010 | 1386 |
Energy_consumption
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGSKEWEDZEROS| Distinct | 30460 |
|---|---|
| Distinct (%) | 68.8% |
| Missing | 11153 |
| Missing (%) | 20.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.537810796 |
| Minimum | -0.163437731 |
|---|---|
| Maximum | 601.04049 |
| Zeros | 10995 |
| Zeros (%) | 19.8% |
| Negative | 208 |
| Negative (%) | 0.4% |
| Memory size | 433.2 KiB |
Quantile statistics
| Minimum | -0.163437731 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.018381028 |
| Q3 | 0.2094223795 |
| 95-th percentile | 3.313893286 |
| Maximum | 601.04049 |
| Range | 601.2039277 |
| Interquartile range (IQR) | 0.2094223795 |
Descriptive statistics
| Standard deviation | 15.45659646 |
|---|---|
| Coefficient of variation (CV) | 10.05103911 |
| Kurtosis | 706.4965549 |
| Mean | 1.537810796 |
| Median Absolute Deviation (MAD) | 0.018381028 |
| Skewness | 23.92149736 |
| Sum | 68105.02673 |
| Variance | 238.9063741 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 10995 | 19.8% |
| 4.34 × 10-5 | 44 | 0.1% |
| 0.003647336 | 28 | 0.1% |
| 0.000660772 | 20 | < 0.1% |
| 0.003697481 | 18 | < 0.1% |
| 0.00240206 | 16 | < 0.1% |
| 0.000257563 | 16 | < 0.1% |
| 0.000626523 | 14 | < 0.1% |
| 0.000212613 | 14 | < 0.1% |
| 2.09 × 10-5 | 14 | < 0.1% |
| Other values (30450) | 33108 | |
| (Missing) | 11153 | 20.1% |
| Value | Count | Frequency (%) |
| -0.163437731 | 1 | |
| -0.155209063 | 1 | |
| -0.137970723 | 1 | |
| -0.134061167 | 1 | |
| -0.120652059 | 1 | |
| -0.108294425 | 1 | |
| -0.105429518 | 1 | |
| -0.099622429 | 1 | |
| -0.097200413 | 1 | |
| -0.088315282 | 1 |
| Value | Count | Frequency (%) |
| 601.04049 | 1 | |
| 597.7365823 | 1 | |
| 584.2018163 | 1 | |
| 572.1592307 | 1 | |
| 567.3288218 | 1 | |
| 566.1299422 | 1 | |
| 561.0921506 | 1 | |
| 551.6003834 | 1 | |
| 540.495127 | 1 | |
| 526.7304677 | 1 |
Energy_production
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGSKEWEDZEROS| Distinct | 20598 |
|---|---|
| Distinct (%) | 46.5% |
| Missing | 11151 |
| Missing (%) | 20.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.532700012 |
| Minimum | -1 × 10-39 |
|---|---|
| Maximum | 611.5089686 |
| Zeros | 20002 |
| Zeros (%) | 36.1% |
| Negative | 6 |
| Negative (%) | < 0.1% |
| Memory size | 433.2 KiB |
Quantile statistics
| Minimum | -1 × 10-39 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.000512197 |
| Q3 | 0.112541005 |
| 95-th percentile | 3.835083374 |
| Maximum | 611.5089686 |
| Range | 611.5089686 |
| Interquartile range (IQR) | 0.112541005 |
Descriptive statistics
| Standard deviation | 15.30355613 |
|---|---|
| Coefficient of variation (CV) | 9.984704125 |
| Kurtosis | 720.5210157 |
| Mean | 1.532700012 |
| Median Absolute Deviation (MAD) | 0.000512197 |
| Skewness | 24.16400807 |
| Sum | 67881.75082 |
| Variance | 234.1988302 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 20002 | |
| 2.09 × 10-5 | 31 | 0.1% |
| 1.9 × 10-5 | 18 | < 0.1% |
| 1.95 × 10-5 | 16 | < 0.1% |
| 1.98 × 10-5 | 16 | < 0.1% |
| 0.002146198 | 16 | < 0.1% |
| 2.06 × 10-5 | 15 | < 0.1% |
| 2.08 × 10-5 | 14 | < 0.1% |
| 0.002145788 | 14 | < 0.1% |
| 0.003697481 | 14 | < 0.1% |
| Other values (20588) | 24133 | |
| (Missing) | 11151 |
| Value | Count | Frequency (%) |
| -1 × 10-39 | 6 | < 0.1% |
| 0 | 20002 | |
| 1 × 10-39 | 3 | < 0.1% |
| 1.86 × 10-18 | 1 | < 0.1% |
| 1 × 10-7 | 2 | < 0.1% |
| 2.98 × 10-7 | 2 | < 0.1% |
| 8.29 × 10-7 | 1 | < 0.1% |
| 9.51 × 10-7 | 1 | < 0.1% |
| 9.52 × 10-7 | 4 | < 0.1% |
| 9.54 × 10-7 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 611.5089686 | 1 | |
| 600.7287295 | 1 | |
| 578.2452544 | 1 | |
| 568.558292 | 1 | |
| 564.5802759 | 1 | |
| 563.3312419 | 1 | |
| 554.177553 | 1 | |
| 546.3336054 | 1 | |
| 534.1878726 | 1 | |
| 518.7316575 | 1 |
| Distinct | 6653 |
|---|---|
| Distinct (%) | 16.6% |
| Missing | 15414 |
| Missing (%) | 27.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 827.1441264 |
| Minimum | 0.124958 |
|---|---|
| Maximum | 127690.2471 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 433.2 KiB |
Quantile statistics
| Minimum | 0.124958 |
|---|---|
| 5-th percentile | 1.01847 |
| Q1 | 9.73778 |
| median | 47.7571 |
| Q3 | 263.6871 |
| 95-th percentile | 2030.632 |
| Maximum | 127690.2471 |
| Range | 127690.1221 |
| Interquartile range (IQR) | 253.94932 |
Descriptive statistics
| Standard deviation | 5981.703144 |
|---|---|
| Coefficient of variation (CV) | 7.231754362 |
| Kurtosis | 235.688449 |
| Mean | 827.1441264 |
| Median Absolute Deviation (MAD) | 45.24724 |
| Skewness | 14.48246875 |
| Sum | 33107270.8 |
| Variance | 35780772.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 177.6304 | 36 | 0.1% |
| 36.3687 | 12 | < 0.1% |
| 1.26052 | 12 | < 0.1% |
| 5.617 | 12 | < 0.1% |
| 14.715 | 12 | < 0.1% |
| 181.306 | 12 | < 0.1% |
| 7.59531 | 12 | < 0.1% |
| 10.6496 | 12 | < 0.1% |
| 17.3494 | 12 | < 0.1% |
| 15.8517 | 12 | < 0.1% |
| Other values (6643) | 39882 | |
| (Missing) | 15414 | 27.8% |
| Value | Count | Frequency (%) |
| 0.124958 | 6 | |
| 0.127624 | 6 | |
| 0.135649 | 6 | |
| 0.135902 | 6 | |
| 0.136654 | 6 | |
| 0.13669 | 6 | |
| 0.137598 | 6 | |
| 0.138485 | 6 | |
| 0.141736 | 6 | |
| 0.145078 | 6 |
| Value | Count | Frequency (%) |
| 127690.2471 | 6 | |
| 124161.994 | 6 | |
| 119854.3217 | 6 | |
| 115567.8801 | 6 | |
| 111935.8957 | 6 | |
| 108404.1799 | 6 | |
| 104859.4489 | 6 | |
| 101534.1126 | 6 | |
| 98369.0322 | 6 | |
| 94617.52644 | 6 |
Population
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 7657 |
|---|---|
| Distinct (%) | 16.6% |
| Missing | 9426 |
| Missing (%) | 17.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 62630.20477 |
| Minimum | 11.471 |
|---|---|
| Maximum | 7714631.064 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 433.2 KiB |
Quantile statistics
| Minimum | 11.471 |
|---|---|
| 5-th percentile | 89.1382 |
| Q1 | 1141.95 |
| median | 6157.68 |
| Q3 | 20042.9 |
| 95-th percentile | 118711.8 |
| Maximum | 7714631.064 |
| Range | 7714619.593 |
| Interquartile range (IQR) | 18900.95 |
Descriptive statistics
| Standard deviation | 456208.8203 |
|---|---|
| Coefficient of variation (CV) | 7.284166194 |
| Kurtosis | 178.4748082 |
| Mean | 62630.20477 |
| Median Absolute Deviation (MAD) | 5758.731 |
| Skewness | 12.93661597 |
| Sum | 2881866242 |
| Variance | 2.081264878 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 103.776 | 12 | < 0.1% |
| 9941.1 | 12 | < 0.1% |
| 294.976 | 12 | < 0.1% |
| 13066.5 | 12 | < 0.1% |
| 161.676 | 12 | < 0.1% |
| 3453.67 | 12 | < 0.1% |
| 10160 | 12 | < 0.1% |
| 3734.34 | 12 | < 0.1% |
| 11282.7 | 12 | < 0.1% |
| 3559.5 | 12 | < 0.1% |
| Other values (7647) | 45894 | |
| (Missing) | 9426 | 17.0% |
| Value | Count | Frequency (%) |
| 11.471 | 6 | |
| 11.821 | 6 | |
| 12.25 | 6 | |
| 12.755 | 6 | |
| 13.317 | 6 | |
| 13.951 | 6 | |
| 14.646 | 6 | |
| 15.39 | 6 | |
| 16.155 | 6 | |
| 16.207 | 6 |
| Value | Count | Frequency (%) |
| 7714631.064 | 6 | |
| 7632247.012 | 6 | |
| 7548343.789 | 6 | |
| 7464042.846 | 6 | |
| 7379227.32 | 6 | |
| 7297269.981 | 6 | |
| 7211822.209 | 6 | |
| 7126262.294 | 6 | |
| 7041712.689 | 6 | |
| 6948810.014 | 6 |
| Distinct | 7430 |
|---|---|
| Distinct (%) | 14.8% |
| Missing | 5082 |
| Missing (%) | 9.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 71.8989137 |
| Minimum | 0 |
|---|---|
| Maximum | 1139.320598 |
| Zeros | 5784 |
| Zeros (%) | 10.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 433.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3.79993914 |
| median | 29.77925957 |
| Q3 | 95.52362689 |
| 95-th percentile | 268.0845979 |
| Maximum | 1139.320598 |
| Range | 1139.320598 |
| Interquartile range (IQR) | 91.72368775 |
Descriptive statistics
| Standard deviation | 113.7287384 |
|---|---|
| Coefficient of variation (CV) | 1.581786602 |
| Kurtosis | 17.42699629 |
| Mean | 71.8989137 |
| Median Absolute Deviation (MAD) | 28.74208029 |
| Skewness | 3.441978433 |
| Sum | 3620685.496 |
| Variance | 12934.22594 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 5784 | 10.4% |
| 68.14592081 | 6 | < 0.1% |
| 128.7796754 | 6 | < 0.1% |
| 36.74813757 | 6 | < 0.1% |
| 83.10244145 | 6 | < 0.1% |
| 8.93068597 | 6 | < 0.1% |
| 42.37612909 | 6 | < 0.1% |
| 493.4825967 | 6 | < 0.1% |
| 9.523323358 | 6 | < 0.1% |
| 5.077479377 | 6 | < 0.1% |
| Other values (7420) | 44520 | |
| (Missing) | 5082 | 9.2% |
| Value | Count | Frequency (%) |
| 0 | 5784 | |
| 0.331847677 | 6 | < 0.1% |
| 0.334977519 | 6 | < 0.1% |
| 0.344453308 | 6 | < 0.1% |
| 0.347076747 | 6 | < 0.1% |
| 0.347198731 | 6 | < 0.1% |
| 0.351858006 | 6 | < 0.1% |
| 0.355312361 | 6 | < 0.1% |
| 0.356964678 | 6 | < 0.1% |
| 0.359532897 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 1139.320598 | 6 | |
| 1127.238553 | 6 | |
| 1115.45434 | 6 | |
| 1110.320147 | 6 | |
| 1106.792855 | 6 | |
| 1101.179716 | 6 | |
| 1095.358362 | 6 | |
| 1082.594019 | 6 | |
| 1053.222783 | 6 | |
| 1027.044351 | 6 |
| Distinct | 6486 |
|---|---|
| Distinct (%) | 12.9% |
| Missing | 5082 |
| Missing (%) | 9.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.695103863 |
| Minimum | 0 |
|---|---|
| Maximum | 166.9136046 |
| Zeros | 11442 |
| Zeros (%) | 20.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 433.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.899446174 |
| median | 2.987592599 |
| Q3 | 4.969454094 |
| 95-th percentile | 10.32595475 |
| Maximum | 166.9136046 |
| Range | 166.9136046 |
| Interquartile range (IQR) | 4.07000792 |
Descriptive statistics
| Standard deviation | 4.5907346 |
|---|---|
| Coefficient of variation (CV) | 1.242383102 |
| Kurtosis | 328.3645712 |
| Mean | 3.695103863 |
| Median Absolute Deviation (MAD) | 2.020993165 |
| Skewness | 10.91730849 |
| Sum | 186078.0403 |
| Variance | 21.07484416 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 11442 | 20.6% |
| 1.348495877 | 12 | < 0.1% |
| 4.698488907 | 6 | < 0.1% |
| 5.51605109 | 6 | < 0.1% |
| 7.042345664 | 6 | < 0.1% |
| 5.748309383 | 6 | < 0.1% |
| 2.211954797 | 6 | < 0.1% |
| 11.56983774 | 6 | < 0.1% |
| 4.406431928 | 6 | < 0.1% |
| 3.627906627 | 6 | < 0.1% |
| Other values (6476) | 38856 | |
| (Missing) | 5082 | 9.2% |
| Value | Count | Frequency (%) |
| 0 | 11442 | |
| 0.231284987 | 6 | < 0.1% |
| 0.232750534 | 6 | < 0.1% |
| 0.233266614 | 6 | < 0.1% |
| 0.249271625 | 6 | < 0.1% |
| 0.251104537 | 6 | < 0.1% |
| 0.253626906 | 6 | < 0.1% |
| 0.25926694 | 6 | < 0.1% |
| 0.26552571 | 6 | < 0.1% |
| 0.29520933 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 166.9136046 | 6 | |
| 153.4088035 | 6 | |
| 31.8073807 | 6 | |
| 31.75636874 | 6 | |
| 31.2189403 | 6 | |
| 31.14421857 | 6 | |
| 29.73922555 | 6 | |
| 29.59851151 | 6 | |
| 29.17988971 | 6 | |
| 29.15970048 | 6 |
CO2_emission
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGSKEWEDZEROS| Distinct | 16993 |
|---|---|
| Distinct (%) | 32.9% |
| Missing | 3826 |
| Missing (%) | 6.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 78.80008185 |
| Minimum | -0.005130222 |
|---|---|
| Maximum | 35584.9335 |
| Zeros | 26954 |
| Zeros (%) | 48.6% |
| Negative | 3 |
| Negative (%) | < 0.1% |
| Memory size | 433.2 KiB |
Quantile statistics
| Minimum | -0.005130222 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4.318822279 |
| 95-th percentile | 141.829587 |
| Maximum | 35584.9335 |
| Range | 35584.93863 |
| Interquartile range (IQR) | 4.318822279 |
Descriptive statistics
| Standard deviation | 902.2214629 |
|---|---|
| Coefficient of variation (CV) | 11.44949906 |
| Kurtosis | 711.3428978 |
| Mean | 78.80008185 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.07524101 |
| Sum | 4067187.425 |
| Variance | 814003.5681 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 26954 | |
| 0.2 | 495 | 0.9% |
| 0.1 | 355 | 0.6% |
| 0.3 | 317 | 0.6% |
| 0.7 | 232 | 0.4% |
| 0.5 | 227 | 0.4% |
| 0.4 | 214 | 0.4% |
| 0.6 | 192 | 0.3% |
| 1 | 154 | 0.3% |
| 0.8 | 139 | 0.3% |
| Other values (16983) | 22335 | |
| (Missing) | 3826 | 6.9% |
| Value | Count | Frequency (%) |
| -0.005130222 | 1 | < 0.1% |
| -0.00307747 | 1 | < 0.1% |
| -0.000138354 | 1 | < 0.1% |
| 0 | 26954 | |
| 1.97 × 10-7 | 1 | < 0.1% |
| 2.78 × 10-7 | 1 | < 0.1% |
| 8.24 × 10-7 | 1 | < 0.1% |
| 1.15 × 10-6 | 1 | < 0.1% |
| 1.23 × 10-6 | 1 | < 0.1% |
| 1.83 × 10-6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 35584.9335 | 1 | |
| 35002.90078 | 1 | |
| 34894.26005 | 1 | |
| 34839.90425 | 1 | |
| 34751.60559 | 1 | |
| 34572.3807 | 1 | |
| 34423.41475 | 1 | |
| 33633.32449 | 1 | |
| 32519.30537 | 1 | |
| 30795.45094 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.
First rows
| Unnamed: 0 | Country | Energy_type | Year | Energy_consumption | Energy_production | GDP | Population | Energy_intensity_per_capita | Energy_intensity_by_GDP | CO2_emission | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | World | all_energy_types | 1980 | 292.899790 | 296.337228 | 27770.91028 | 4298126.522 | 68.145921 | 10.547 | 4946.627130 |
| 1 | 1 | World | coal | 1980 | 78.656134 | 80.114194 | 27770.91028 | 4298126.522 | 68.145921 | 10.547 | 1409.790188 |
| 2 | 2 | World | natural_gas | 1980 | 53.865223 | 54.761046 | 27770.91028 | 4298126.522 | 68.145921 | 10.547 | 1081.593377 |
| 3 | 3 | World | petroleum_n_other_liquids | 1980 | 132.064019 | 133.111109 | 27770.91028 | 4298126.522 | 68.145921 | 10.547 | 2455.243565 |
| 4 | 4 | World | nuclear | 1980 | 7.575700 | 7.575700 | 27770.91028 | 4298126.522 | 68.145921 | 10.547 | 0.000000 |
| 5 | 5 | World | renewables_n_other | 1980 | 20.702344 | 20.775178 | 27770.91028 | 4298126.522 | 68.145921 | 10.547 | 0.000000 |
| 6 | 6 | Afghanistan | all_energy_types | 1980 | 0.026583 | 0.072561 | NaN | 13356.500 | 1.990283 | 0.000 | NaN |
| 7 | 7 | Afghanistan | coal | 1980 | 0.002479 | 0.002355 | NaN | 13356.500 | 1.990283 | 0.000 | NaN |
| 8 | 8 | Afghanistan | natural_gas | 1980 | 0.002094 | 0.062820 | NaN | 13356.500 | 1.990283 | 0.000 | NaN |
| 9 | 9 | Afghanistan | petroleum_n_other_liquids | 1980 | 0.014624 | 0.000000 | NaN | 13356.500 | 1.990283 | 0.000 | NaN |
Last rows
| Unnamed: 0 | Country | Energy_type | Year | Energy_consumption | Energy_production | GDP | Population | Energy_intensity_per_capita | Energy_intensity_by_GDP | CO2_emission | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 55430 | 55430 | Zambia | natural_gas | 2019 | 0.000000 | 0.000000 | 247.1819 | 17873.85 | 11.586567 | 0.837831 | 0.000000 |
| 55431 | 55431 | Zambia | petroleum_n_other_liquids | 2019 | 0.052135 | 0.000000 | 247.1819 | 17873.85 | 11.586567 | 0.837831 | 4.202188 |
| 55432 | 55432 | Zambia | nuclear | 2019 | NaN | NaN | 247.1819 | 17873.85 | 11.586567 | 0.837831 | 0.000000 |
| 55433 | 55433 | Zambia | renewables_n_other | 2019 | 0.120811 | 0.123466 | 247.1819 | 17873.85 | 11.586567 | 0.837831 | 0.000000 |
| 55434 | 55434 | Zimbabwe | all_energy_types | 2019 | 0.168651 | 0.143462 | 37.6204 | 14654.20 | 11.508701 | 4.482962 | 8.964759 |
| 55435 | 55435 | Zimbabwe | coal | 2019 | 0.045064 | 0.075963 | 37.6204 | 14654.20 | 11.508701 | 4.482962 | 4.586869 |
| 55436 | 55436 | Zimbabwe | natural_gas | 2019 | 0.000000 | 0.000000 | 37.6204 | 14654.20 | 11.508701 | 4.482962 | 0.000000 |
| 55437 | 55437 | Zimbabwe | petroleum_n_other_liquids | 2019 | 0.055498 | 0.000000 | 37.6204 | 14654.20 | 11.508701 | 4.482962 | 4.377890 |
| 55438 | 55438 | Zimbabwe | nuclear | 2019 | NaN | NaN | 37.6204 | 14654.20 | 11.508701 | 4.482962 | 0.000000 |
| 55439 | 55439 | Zimbabwe | renewables_n_other | 2019 | 0.068089 | 0.067499 | 37.6204 | 14654.20 | 11.508701 | 4.482962 | 0.000000 |